ICDMerchandiseTaxExemptionLineItem

Entity Definition

Logical Name : ICDMerchandiseTaxExemptionLineItem
Physical Name : DO_LTM_ICD_MR_TX_EXMPTN

A tax exemption that applies to a single ICDMerchandiseLineItem tax. This is a single line item, single tax type exemption. It applies in scenarios where specific items are granted exemption from tax on a temporary basis. For example, this is a common practice in Brazil states.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TaxGroupRuleID (FK)(PK) System assigned unique identifier for the TaxGroupRule. ID_RU_TX_GRP Identity integer ICDMerchandiseTaxLineItem(DO_LTM_ICD_MR_TX)
InventoryControlDocumentID (FK)(PK) The reference number that uniquely identifies the InventoryControlDocument. ID_ICD Identity integer ICDMerchandiseTaxLineItem(DO_LTM_ICD_MR_TX)
InventoryControlDocumentLineItemID (FK)(PK) A unique system assigned identifier for the LineItem within the confines of the InventoryControlDocument. IC_LTM_ICD LineNumber smallint ICDMerchandiseTaxLineItem(DO_LTM_ICD_MR_TX)
ExemptionAmount The monetary amount of the tax exemption MO_TX_EXM MoneyShortRetail decimal(7,2)
ReasonCode A reason code for the tax exemption. Typically the CUSTOMER belongs a special group, such foreign diplomats, religious bodies, etc. The bearer must have a certificate to qualify for the tax exemption. AUTHORITY. RC_TX_EXM Code2 char(2)

Relationships

Parent Entity Verb Phrase Child Entity
ICDMerchandiseTaxLineItem is exempted by ICDMerchandiseTaxExemptionLineItem

Logical Views containing ICDMerchandiseTaxExemptionLineItem

Logical View
Logical 05300 - Taxation - Inventory Control Document View